<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/9/12
 * Time: 10:27
 * 查询每个机构的总容纳人数
 */
$oa_oseid = $route->bodyParams['oa_oseid'];  //参与者ID

//

$sql = "SELECT SUM(oc_limit_number * (oc_weekday_frequency + oc_weekend_frequency)) AS limit_num FROM art_oa_classroom WHERE oc_oesid = ".$oa_oseid;
//$sql  = "SELECT oc_limit_number from art_oa_classroom WHERE oc_oesid = ".$oa_oseid;
$re=$db->mysqlDB->query($sql);

$response->responseData(true, $re);